<?xml version="1.0"?>
<?xml-stylesheet href="chrome://global/skin" type="text/css"?>
<?xml-stylesheet href="chrome://mochikit/content/tests/SimpleTest/test.css" type="text/css"?>

<!--
    storage listbox with multiqueries
-->

<window title="XUL Template Tests" width="500" height="600"
        onload="test_template();"
        xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul">
  <script type="application/javascript"
          src="chrome://mochikit/content/tests/SimpleTest/SimpleTest.js"></script>

  <body xmlns="http://www.w3.org/1999/xhtml" style="height: 300px; overflow: auto;"/>

  <data id="output">
      <listitem anyid="true" label="Mammal: African Elephant"/>
      <listitem anyid="true" label="Mammal: Gorilla" style="font-weight:bold"/>
      <listitem anyid="true" label="Mammal: HIPPOPOTAMUS"/>
      <listitem anyid="true" label="Mammal: LAMA"/>
      <listitem anyid="true" label="Mammal: Lion"/>
      <listitem anyid="true" label="Mammal: Nine-banded Armadillo" style="font-weight:bold"/>
      <listitem anyid="true" label="Mammal: Polar Bear"/>
      <listitem anyid="true" label="Mammal: aardvark"/>
      <listitem anyid="true" label="Bird: Barn Owl" style="font-style:italic"/>
      <listitem anyid="true" label="Bird: Emu"/>
      <listitem anyid="true" label="Bird: Raven"/>
  </data>

<script src="templates_shared.js"/>

<script>
<![CDATA[
SimpleTest.waitForExplicitFinish();

copyToProfile('animals.sqlite');

var testid ="storage listbox with multiqueries";
var queryType = "storage";
var isTreeBuilder = false;
var needsOpen = false;
var notWorkingYet = false;
var notWorkingYetDynamic = false;
var expectedOutput = document.getElementById("output");

var changes = [];
]]>
</script>

<listbox  xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root" 
              flex="1"  datasources="profile:animals.sqlite" ref="." querytype="storage">
    <template>
        <queryset>
            <query>SELECT * FROM animals WHERE species_id = 5 ORDER BY name</query>
            <rule>
                <where subject="?id" rel="greater" value="12"/>
                <action>
                    <listitem uri="?" label="Mammal: ?name"  style="font-weight:bold"/>
                </action>
            </rule>
            <rule>
                <action>
                    <listitem uri="?" label="Mammal: ?name"/>
                </action>
            </rule>
        </queryset>
        <queryset>
            <!-- we use aliases on columns just to have different "column names" in the result set
                to "similate" a result set from another table for example  -->
            <query>SELECT * FROM animals WHERE species_id = 2 ORDER BY name</query>
            <rule>
                <where subject="?id" rel="equals" value="3"/>
                <action>
                    <listitem uri="?" label="Bird: ?name"  style="font-style:italic"/>
                </action>
            </rule>
            <rule>
                <action>
                    <listitem uri="?" label="Bird: ?name"/>
                </action>
            </rule>
        </queryset>
    </template>
</listbox>
</window>
